EMT Practice Test

1. Question Content...

---

Question1: What is a valid selection from the home page of the IBM Netezza Performance Server web console?

Question2: When choosing a distribution key for a large fact table, what is a valid choice?

Question3: What command is used to verify the release of IBM Netezza Performance Server Analytics installed?

Question4: When restoring a database using nzrestore utility, which is true for the npshost option?

Question5: What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?

Question6: To how many resource groups can a user be assigned?

Question7: What are two important factors to consider when selecting a distribution key?

Question8: Which two external methods can IBM Netezza Performance Server use to authenticate database users?

Question9: What is a purpose of the command nzsystem?

Question10: What are two primary purposes of UDX?

Question11: How can a user update statistics on a table?

Question12: Which statement is accurate regarding snippets?

Question13: IBM Netezza Performance Server drivers for the Go Language can be obtained from which location?

Question14: What is the name of the IBM Netezza Performance Server Replication node at the target nodes when using Netezza Replication Services?

Question15: Which two scenarios can be addressed using the nz_check_disk_scan_speeds command?

Question16: Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?

Question17: To enable or disable multiple schema support on the IBM Netezza Performance Server, which configuration file needs to be updated?

Question18: When computing the row size for a table row, what overhead should be accounted for?

Question19: By default, when are the postgres logs rotated on an IBM Netezza Performance Server?

Question20: Which level of transaction isolation does IBM Netezza Performance Server implement?